﻿-- Creating table 'AppointedPatients'
-- Creating table 'AppointedPatients'
-- Creating table 'AppointedPatients'
-- Creating table 'AppointedPatients'
-- Creating table 'AppointedPatients'
CREATE TABLE [dbo].[AppointedPatients] (
    [HN] nvarchar(8)  NOT NULL,
    [Title] nvarchar(50)  NOT NULL,
    [FirstName] nvarchar(50)  NOT NULL,
    [LastName] nvarchar(50)  NOT NULL,
    [Sex] int  NOT NULL,
    [BirthDate] datetime  NULL,
    [PIN] nvarchar(13)  NULL,
    [Payor] nvarchar(50)  NULL,
    [Address] nvarchar(255)  NULL,
    [Tambon] nvarchar(100)  NULL,
    [Amphur] nvarchar(100)  NULL,
    [Province] nvarchar(100)  NULL,
    [Phone] nvarchar(50)  NULL
);














